| Project Name | Robotic Framework for Requirement Management, Estimations, & Project Proposals |
|---|---|
| Technologies | Python, RPA Tools, NLP, Web Interface |
| Problem Statement | Manual proposal creation is slow, error-prone, and inconsistent. |
| AI Component | NLP for requirement parsing, ML for estimation prediction, AI proposal generation |
| Proposed Solution | RPA extracts requirements → AI predicts timelines → Automated proposal document generated |
| Impact | Speeds up project cycles, improves accuracy, increases efficiency globally |
| Table Name | Description |
|---|---|
| requirements_master | Stores extracted requirements |
| estimation_model_data | ML training data for prediction |
| proposal_templates | Stores proposal formats |
| generated_proposals | Stores final AI-generated proposals |
| project_type_master | Type/category of project (Web, Mobile, AI, Cloud) |
| resource_cost_master | Cost per resource type per hour |
| timeline_rules | ML rules/datasets for timeline patterns |
| ID | Requirement Text | Category |
|---|---|---|
| 1 | User login using email & OTP | Authentication |
| 2 | Dashboard with analytics widgets | UI/Analytics |
| 3 | Export reports to PDF & Excel | Reporting |
| Role | Hourly Cost (USD) |
|---|---|
| Frontend Developer | 25 |
| Backend Developer | 30 |
| QA Engineer | 20 |
| Project Manager | 45 |
| Requirement Category | Avg Hours | Complexity |
|---|---|---|
| Authentication | 28 | Medium |
| UI/Analytics | 52 | High |
| Reporting | 36 | Medium |
| Template ID | Name | Description |
|---|---|---|
| 101 | Standard Proposal | General format with scope, cost, timeline, assumptions |
| 102 | Enterprise Proposal | Includes risk analysis & SLA terms |
| ID | Project Name | Status | Generated File |
|---|---|---|---|
| 501 | AI Analytics Dashboard | Completed | proposal_501.pdf |